EXIM v1.2 Unregistered version - Product description ****BEST VIEWED MAXIMISED**** What is this EXIM? ------------------ EXIM contains the 16/32 bit Delphi VCL components TExport and TImport which make ridiculously easy the importing and exporting of formatted ASCII files. ** PLEASE NOTE THAT THE UNREGISTERED VERSION IS FULLY FUNCTIONAL BUT ** ** CAN ONLY RUN WHEN THE DELPHI IDE IS LOADED ** TExport General stuff --------------------- o Export from tables, queries and stored procedures o Export of calculated fields also supported o Use the Delphi Fields Editor to control field sequence, width and format of field values o Component editor available for easy setting of properties o Events available for custom user processing before and after each record is exported TExport Properties ------------------ Datasource - can be connected to a table, query or stored procedure DelimitStringsOnly - choose whether non-string fields are field delimited or not DisplayErrorDialogs - turn on/off run-time error dialogs ExportMemos - choose whether memo data is exported or not ExportOrder - choose to export fields in order or by order of their Tag value ExportType - export data in variable or fixed length format FieldDelimiter - specify character that delimits fields in variable length format FieldNames - export field names as first record of export ASCII file FieldSeparator - specify character that separates fields in variable length format Filename - set export ASCII file path/name to any connected drive Gauge - connect to a gauge to automatically show progress graphically Interval - frequency of OutputLabel update MatchTagValue - export only those fields whose Tag property matches this value NumRecords - limit number of records exported to this maximum Name - unique TExport instance name OutputLabel - connect to a label to automatically show progress textually OverwriteFile - turn on/off confirmation run-time of attempt to overwrite existing export file ProcessMessages - choose whether background Windows message processing is on or off during export RecordSeparator - specify character(s) that separates records in either format ReplaceMemoReturns - choose whether to automatically replace in-memo CR/LFs with spaces Version - returns the current TExport version details TExport Methods --------------- Execute - launches export - returns run-time error codes TExport Events -------------- AfterExport - enter your own code, for example - to update related tables, audit, etc.. BeforeExport - enter your own code, for example - to filter/reject records for export TImport General Stuff --------------------- o Use the Fields Editor properties to control field sequence and width o Component editor available for easy setting of properties o Events available for custom user processing before and after each record is exported Properties ---------- CreateErrorLog - switch on/off automatic creation of error log file DisplayErrorDialogs - switch on/off run-time error dialogs FieldDelimiter - specify character that delimits fields in variable length format FieldSeparator - specify character that separates fields in variable length format Gauge - connect to a gauge to automatically show progress graphically ImportOrder - import either by field name, field order or Tag value ImportType - import data in variable or fixed length format Interval - frequency of OutputLabel update Name - unique TImport instance name NumRecords - limit number of records exported to this maximum OutputLabel - connect to a label to automatically show progress textually ProcessMessages - turn on/off background Windows message processing during import Table - connect to table that will receive the imported data Version - returns the TImport version details Methods ------- Execute - launches import process Events ------ BeforePost - e.g. use to filter imported records AfterPost - e.g. use to update related tables, audit etc.. OnTableError - allows custom error processing of table errors (e.g. key violations) OnFieldError - allows custom error processing of field errors (e.g. invalid date)